06. Dimensional Modeling
DimModeling1
DimModeling2
QUIZ QUESTION::
Match the type of data being captured in a table with the type of table (Fact VS. Dimension) it would be best captured in.
ANSWER CHOICES:
|
Type of data |
Fact VS. Dimension table |
|---|---|
Number of items bought by a customer |
|
Type of shirt ordered by the customer |
|
Instances of positive feedback from customer |
|
Type of furniture the customer was browsing on an online furniture website |
|
Number of shares sold for a specific company |
SOLUTION:
|
Type of data |
Fact VS. Dimension table |
|---|---|
|
Number of items bought by a customer |
|
|
Instances of positive feedback from customer |
|
|
Number of shares sold for a specific company |
|
|
Type of shirt ordered by the customer |
|
|
Type of furniture the customer was browsing on an online furniture website |
|
|
Type of shirt ordered by the customer |
|
|
Type of furniture the customer was browsing on an online furniture website |
|
|
Number of items bought by a customer |
|
|
Instances of positive feedback from customer |
|
|
Number of shares sold for a specific company |
|
|
Number of items bought by a customer |
|
|
Instances of positive feedback from customer |
|
|
Number of shares sold for a specific company |
QUIZ QUESTION::
Match the type of data being captured in a table with the type of table (Fact VS. Dimension) it would be best captured in.
ANSWER CHOICES:
|
Type of data |
Fact VS. Dimension table |
|---|---|
Length of phone call a customer service rep attended to resolution. |
|
Location of the store |
|
Date when customer placed the order for 4 shirts. |
|
Employee ID of the sales person who made the sale |
SOLUTION:
|
Type of data |
Fact VS. Dimension table |
|---|---|
|
Length of phone call a customer service rep attended to resolution. |
|
|
Location of the store |
|
|
Date when customer placed the order for 4 shirts. |
|
|
Employee ID of the sales person who made the sale |
|
|
Location of the store |
|
|
Date when customer placed the order for 4 shirts. |
|
|
Employee ID of the sales person who made the sale |
|
|
Location of the store |
|
|
Date when customer placed the order for 4 shirts. |
|
|
Employee ID of the sales person who made the sale |